﻿CREATE TABLE [dbo].[Disk] (
    [Name]               VARCHAR (50)     NOT NULL,
    [Size]               INT              NULL,
    [Used]               INT              NULL,
    [ServerID]           UNIQUEIDENTIFIER NOT NULL,
    [VolumeSerialNumber] VARCHAR (50)     NOT NULL,
    CONSTRAINT [PK_Disk] PRIMARY KEY CLUSTERED ([VolumeSerialNumber] ASC),
    CONSTRAINT [FK_Disk_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

